<?
$lastUpdated = $_GET['lastUpdated'];
$g4_path = "../..";                                                                                                                                                                                                              
include_once("$g4_path/common.php");
include_once("$g4[path]/lib/finalpaper.lib.php");

//include_once("./_common.php");

$g4[title] = "최근 게시물";
//include_once("../head.php");

$sql_common = " from $g4[board_new_table] a, $g4[board_table] b, $g4[group_table] c 
               where a.bo_table = b.bo_table and b.gr_id = c.gr_id and b.bo_use_search = '1' ";
if ($gr_id)
    $sql_common .= " and b.gr_id = '$gr_id' ";
if ($bo_table)
    $sql_common .= " and b.bo_table = '$bo_table' ";
if ($view == "w")
    $sql_common .= " and a.wr_id = a.wr_parent ";
else if ($view == "c")
    $sql_common .= " and a.wr_id <> a.wr_parent ";
if ($mb_id)
    $sql_common .= " and a.mb_id = '$mb_id' ";
if ($lastUpdated)
    $sql_common .= " and bn_datetime > '$lastUpdated' ";
$sql_order = " AND b.gr_id!='lab' order by a.bn_id desc ";

$sql = " select count(*) as cnt $sql_common ";
$row = sql_fetch($sql);
$total_count = $row[cnt];

$rows = $config[cf_new_rows];
$total_page  = ceil($total_count / $rows);  // 전체 페이지 계산
if (!$page) $page = 1; // 페이지가 없으면 첫 페이지 (1 페이지)
$from_record = ($page - 1) * $rows; // 시작 열을 구함

/*
$group_select = "<select name=gr_id id=gr_id onchange='select_change();'><option value=''>전체그룹";
$sql = " select gr_id, gr_subject from $g4[group_table] order by gr_id ";
$result = sql_query($sql);
for ($i=0; $row=sql_fetch_array($result); $i++) 
{
    $group_select .= "<option value='$row[gr_id]'>$row[gr_subject]";
}
$group_select .= "</select>";
*/

$list = array();
$sql = " select a.*, b.bo_subject, c.gr_subject, c.gr_id
          $sql_common
          $sql_order
          limit $from_record, $rows ";
$result = sql_query($sql);
for ($i=0; $row=sql_fetch_array($result); $i++) 
{
    $tmp_write_table = $g4[write_prefix] . $row[bo_table];

	$row4 = sql_fetch(" select wr_option from $tmp_write_table where wr_id = '$row[wr_id]'");
	if(!strstr($row4[wr_option], "anonym")||$mb_id=='')
	{
		if ($row[wr_id] == $row[wr_parent]) // 원글
		{
			$comment = "";
			$comment_link = "";
			$row2 = sql_fetch(" select * from $tmp_write_table where wr_id = '$row[wr_id]' ");
			$list[$i] = $row2;

			$name = get_sideview($row2[mb_id], cut_str($row2[wr_name], $config[cf_cut_name]), $row2[wr_email], $row2[wr_homepage]);

			// 당일인 경우 시간으로 표시함
			$datetime = substr($row2[wr_datetime],0,10);
			$datetime2 = $row2[wr_datetime];
			if ($datetime == $g4[time_ymd])
				$datetime2 = substr($datetime2,11,5);
			else
				$datetime2 = substr($datetime2,5,5);

		}
		else // 코멘트
		{
			$comment = "[코] ";
			$comment_link = "#c_{$row[wr_id]}";
			$row2 = sql_fetch(" select * from $tmp_write_table where wr_id = '$row[wr_id]' ");
			$row3 = sql_fetch(" select mb_id, wr_name, wr_email, wr_homepage, wr_datetime from $tmp_write_table where wr_id = '$row[wr_id]'");
			$list[$i] = $row2;
			$list[$i][mb_id] = $row3[mb_id];
			$list[$i][wr_name] = $row3[wr_name];
			$list[$i][wr_email] = $row3[wr_email];
			$list[$i][wr_homepage] = $row3[wr_homepage];

			$name = get_sideview($row3[mb_id], cut_str($row3[wr_name], $config[cf_cut_name]), $row3[wr_email], $row3[wr_homepage]);
			// 당일인 경우 시간으로 표시함
			$datetime = substr($row3[wr_datetime],0,10);
			$datetime2 = $row3[wr_datetime];
			if ($datetime == $g4[time_ymd])
				$datetime2 = substr($datetime2,11,5);
			else
				$datetime2 = substr($datetime2,5,5);
		}

		$list[$i][gr_id] = $row[gr_id];
		$list[$i][bo_table] = $row[bo_table];
		if(strstr($list[$i][wr_option], "anonym"))
				$name='*익명';
		$list[$i][name] = $name;
		$list[$i][comment] = $comment;
		//$list[$i][href] = "./board.php?bo_table=$row[bo_table]&wr_id=$row2[wr_id]{$comment_link}";
		$list[$i][href] = "./board.php?bo_table=$row[bo_table]&wr_id=$row[wr_parent]";
		$list[$i][datetime] = $datetime;
		$list[$i][datetime2] = $datetime2;

		$list[$i][gr_subject] = $row[gr_subject];
		$list[$i][bo_subject] = $row[bo_subject];
		if(strstr($list[$i][wr_option], "secret"))
			$row2['wr_content']='비밀글 입니다.';
		if ($row[wr_id] == $row[wr_parent]) // 원글
			$list[$i][wr_subject] = $row2[wr_subject];
		else
			$list[$i][wr_subject] = "[코] ".$row2[wr_content];
	}
	else
		$i--;
}

//$write_pages = get_paging($config[cf_write_pages], $page, $total_page, "?gr_id=$gr_id&bo_table=$bo_table&view=$view&mb_id=$mb_id&page=");

//$new_skin_path = "$g4[path]/skin/new/$config[cf_new_skin]";

//echo "<script language=\"javascript\" src=\"$g4[path]/js/sideview.js\"></script>\n";

//include_once("$new_skin_path/new.skin.php");

//include_once("./_tail.php");
header ("Content-Type:text/xml"); 
echo "<newPosts><total>".count($list)."</total>";
echo "<lastChecked>".date("Y-m-d+H:i:s")."</lastChecked>";
for($i=0; $i<count($list) && $i<20; $i++) {
	echo "<post>{$i}";
	echo "<group>{$list[$i][gr_subject]}</group><board>{$list[$i][bo_subject]}</board>";
	echo "<title>".htmlspecialchars(fp_cutstr($list[$i][wr_subject],25,'…'))."</title><bo_table>{$list[$i][bo_table]}</bo_table><wr_id>{$list[$i][wr_id]}</wr_id>";	//<URL>{$list[$i][href]}</URL>";
	echo "<name>{$list[$i][wr_name]}</name><datetime>{$list[$i][datetime2]}</datetime>";
	echo "</post>";
}
echo "</newPosts>";
?>